Incorrect values might be returned with an implicit pass-through Structured Query Language (SQL) query when you use nested views to create calculated variables.

The problem can manifest itself in the following conditions:

• There is a cascade of nested views.
• An arithmetic expression in one PROC SQL view references one or more derived arithmetic expressions that are defined in another PROC SQL view.

To circumvent the problem, you can use CREATE TABLE statements instead of CREATE VIEW statements.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Base SAS 9.4_M5 is available at: